USE Liberty
GO
---------------------------------------------------------------------------------------------------
--	TypesOfDischarge Population Script
---------------------------------------------------------------------------------------------------

SET NOCOUNT ON 

IF EXISTS(SELECT 1 FROM dbo.TypesOfDischarge)
BEGIN
	PRINT 'TypesOfDischarge already populated; no action taken'
END
ELSE
BEGIN
	INSERT INTO dbo.TypesOfDischarge (Description, Active, DisplayOrder)
	VALUES('N/A', 1, 1)
	INSERT INTO dbo.TypesOfDischarge (Description, Active, DisplayOrder)
	VALUES('Honorable', 1, 2)
	INSERT INTO dbo.TypesOfDischarge (Description, Active, DisplayOrder)
	VALUES('General', 1, 3)
	INSERT INTO dbo.TypesOfDischarge (Description, Active, DisplayOrder)
	VALUES('Under Other Than Honorable', 1, 4)
	INSERT INTO dbo.TypesOfDischarge (Description, Active, DisplayOrder)
	VALUES('Bad Conduct', 1, 5)
	INSERT INTO dbo.TypesOfDischarge (Description, Active, DisplayOrder)
	VALUES('Dishonorable', 1, 6)

	PRINT 'TypesOfDischarge has been populated'
END

SELECT * FROM dbo.TypesOfDischarge

